Overview
Brought to you by YData
Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 7253 |
| Missing cells | 30498 |
| Missing cells (%) | 23.4% |
| Duplicate rows | 1 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 3.6 MiB |
| Average record size in memory | 524.8 B |
Variable types
| Text | 3 |
|---|---|
| Categorical | 5 |
| Numeric | 7 |
| Unsupported | 3 |
| Dataset has 1 (< 0.1%) duplicate rows | Duplicates |
Brand is highly overall correlated with Transmission | High correlation |
Car_Age is highly overall correlated with Kilometers_Driven and 2 other fields | High correlation |
Kilometers_Driven is highly overall correlated with Car_Age and 2 other fields | High correlation |
Kilometers_Driven_log is highly overall correlated with Car_Age and 2 other fields | High correlation |
Price is highly overall correlated with Price_log and 1 other fields | High correlation |
Price_log is highly overall correlated with Price and 1 other fields | High correlation |
Transmission is highly overall correlated with Brand and 2 other fields | High correlation |
Year is highly overall correlated with Car_Age and 2 other fields | High correlation |
Fuel_Type is highly imbalanced (53.6%) | Imbalance |
Owner_Type is highly imbalanced (61.0%) | Imbalance |
Mileage has 7253 (100.0%) missing values | Missing |
Engine has 7253 (100.0%) missing values | Missing |
Power has 7253 (100.0%) missing values | Missing |
New_Price has 6247 (86.1%) missing values | Missing |
Price has 1234 (17.0%) missing values | Missing |
Price_log has 1234 (17.0%) missing values | Missing |
Kilometers_Driven is highly skewed (γ1 = 61.58257466) | Skewed |
Mileage is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Engine is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Power is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2025-01-31 05:34:12.918866 |
|---|---|
| Analysis finished | 2025-01-31 05:34:18.751464 |
| Duration | 5.83 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
Name
Text
| Distinct | 2041 |
|---|---|
| Distinct (%) | 28.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 532.5 KiB |
Length
| Max length | 59 |
|---|---|
| Median length | 48 |
| Mean length | 26.15759 |
| Min length | 11 |
Unique
| Unique | 862 ? |
|---|---|
| Unique (%) | 11.9% |
Sample
| 1st row | Maruti Wagon R LXI CNG |
|---|---|
| 2nd row | Hyundai Creta 1.6 CRDi SX Option |
| 3rd row | Honda Jazz V |
| 4th row | Maruti Ertiga VDI |
| 5th row | Audi A4 New 2.0 TDI Multitronic |
| Value | Count | Frequency (%) |
| maruti | 1444 | 4.1% |
| hyundai | 1340 | 3.8% |
| honda | 743 | 2.1% |
| at | 655 | 1.9% |
| diesel | 609 | 1.7% |
| 1.2 | 521 | 1.5% |
| toyota | 507 | 1.4% |
| tdi | 479 | 1.4% |
| mt | 419 | 1.2% |
| swift | 418 | 1.2% |
| Other values (907) | 27958 |
Most occurring characters
| Value | Count | Frequency (%) |
| 27840 | 14.7% | |
| a | 11809 | 6.2% |
| i | 11426 | 6.0% |
| e | 9233 | 4.9% |
| t | 7952 | 4.2% |
| o | 7950 | 4.2% |
| n | 7822 | 4.1% |
| r | 7647 | 4.0% |
| u | 5214 | 2.7% |
| d | 4930 | 2.6% |
| Other values (59) | 87898 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 97297 | |
| Uppercase Letter | 44507 | |
| Space Separator | 27840 | 14.7% |
| Decimal Number | 15634 | 8.2% |
| Other Punctuation | 2704 | 1.4% |
| Dash Punctuation | 1401 | 0.7% |
| Open Punctuation | 169 | 0.1% |
| Close Punctuation | 169 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 11809 | |
| i | 11426 | |
| e | 9233 | |
| t | 7952 | |
| o | 7950 | |
| n | 7822 | |
| r | 7647 | 7.9% |
| u | 5214 | 5.4% |
| d | 4930 | 5.1% |
| l | 4156 | 4.3% |
| Other values (16) | 19158 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 3941 | 8.9% |
| T | 3922 | 8.8% |
| M | 3654 | 8.2% |
| D | 3536 | 7.9% |
| V | 3220 | 7.2% |
| C | 3080 | 6.9% |
| I | 3025 | 6.8% |
| X | 2484 | 5.6% |
| A | 2430 | 5.5% |
| H | 2419 | 5.4% |
| Other values (16) | 12796 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 3685 | |
| 2 | 3474 | |
| 1 | 3452 | |
| 5 | 1469 | 9.4% |
| 4 | 962 | 6.2% |
| 3 | 899 | 5.8% |
| 8 | 585 | 3.7% |
| 6 | 577 | 3.7% |
| 7 | 364 | 2.3% |
| 9 | 167 | 1.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 2678 | |
| / | 22 | 0.8% |
| & | 4 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 27840 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1401 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 169 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 169 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 141804 | |
| Common | 47917 | 25.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 11809 | 8.3% |
| i | 11426 | 8.1% |
| e | 9233 | 6.5% |
| t | 7952 | 5.6% |
| o | 7950 | 5.6% |
| n | 7822 | 5.5% |
| r | 7647 | 5.4% |
| u | 5214 | 3.7% |
| d | 4930 | 3.5% |
| l | 4156 | 2.9% |
| Other values (42) | 63665 |
Common
| Value | Count | Frequency (%) |
| 27840 | ||
| 0 | 3685 | 7.7% |
| 2 | 3474 | 7.3% |
| 1 | 3452 | 7.2% |
| . | 2678 | 5.6% |
| 5 | 1469 | 3.1% |
| - | 1401 | 2.9% |
| 4 | 962 | 2.0% |
| 3 | 899 | 1.9% |
| 8 | 585 | 1.2% |
| Other values (7) | 1472 | 3.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 189721 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 27840 | 14.7% | |
| a | 11809 | 6.2% |
| i | 11426 | 6.0% |
| e | 9233 | 4.9% |
| t | 7952 | 4.2% |
| o | 7950 | 4.2% |
| n | 7822 | 4.1% |
| r | 7647 | 4.0% |
| u | 5214 | 2.7% |
| d | 4930 | 2.6% |
| Other values (59) | 87898 |
Location
Categorical
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 395.7 KiB |
| Mumbai | |
|---|---|
| Hyderabad | |
| Coimbatore | |
| Kochi | |
| Pune | |
| Other values (6) |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 6.8470978 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mumbai |
|---|---|
| 2nd row | Pune |
| 3rd row | Chennai |
| 4th row | Chennai |
| 5th row | Coimbatore |
Common Values
| Value | Count | Frequency (%) |
| Mumbai | 949 | |
| Hyderabad | 876 | |
| Coimbatore | 772 | |
| Kochi | 772 | |
| Pune | 765 | |
| Delhi | 660 | |
| Kolkata | 654 | |
| Chennai | 591 | |
| Jaipur | 499 | |
| Bangalore | 440 |
Length
| Value | Count | Frequency (%) |
| mumbai | 949 | |
| hyderabad | 876 | |
| coimbatore | 772 | |
| kochi | 772 | |
| pune | 765 | |
| delhi | 660 | |
| kolkata | 654 | |
| chennai | 591 | |
| jaipur | 499 | |
| bangalore | 440 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 7301 | |
| e | 4379 | 8.8% |
| i | 4243 | 8.5% |
| o | 3410 | 6.9% |
| b | 2872 | 5.8% |
| r | 2587 | 5.2% |
| n | 2387 | 4.8% |
| d | 2302 | 4.6% |
| h | 2298 | 4.6% |
| u | 2213 | 4.5% |
| Other values (17) | 15670 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 42409 | |
| Uppercase Letter | 7253 | 14.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 7301 | |
| e | 4379 | |
| i | 4243 | |
| o | 3410 | |
| b | 2872 | 6.8% |
| r | 2587 | 6.1% |
| n | 2387 | 5.6% |
| d | 2302 | 5.4% |
| h | 2298 | 5.4% |
| u | 2213 | 5.2% |
| Other values (8) | 8417 |
Uppercase Letter
| Value | Count | Frequency (%) |
| K | 1426 | |
| C | 1363 | |
| M | 949 | |
| H | 876 | |
| P | 765 | |
| D | 660 | |
| J | 499 | 6.9% |
| B | 440 | 6.1% |
| A | 275 | 3.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49662 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 7301 | |
| e | 4379 | 8.8% |
| i | 4243 | 8.5% |
| o | 3410 | 6.9% |
| b | 2872 | 5.8% |
| r | 2587 | 5.2% |
| n | 2387 | 4.8% |
| d | 2302 | 4.6% |
| h | 2298 | 4.6% |
| u | 2213 | 4.5% |
| Other values (17) | 15670 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49662 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 7301 | |
| e | 4379 | 8.8% |
| i | 4243 | 8.5% |
| o | 3410 | 6.9% |
| b | 2872 | 5.8% |
| r | 2587 | 5.2% |
| n | 2387 | 4.8% |
| d | 2302 | 4.6% |
| h | 2298 | 4.6% |
| u | 2213 | 4.5% |
| Other values (17) | 15670 |
Year
Real number (ℝ)
High correlation 
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2013.3654 |
| Minimum | 1996 |
|---|---|
| Maximum | 2019 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.8 KiB |
Quantile statistics
| Minimum | 1996 |
|---|---|
| 5-th percentile | 2007 |
| Q1 | 2011 |
| median | 2014 |
| Q3 | 2016 |
| 95-th percentile | 2018 |
| Maximum | 2019 |
| Range | 23 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.2544208 |
|---|---|
| Coefficient of variation (CV) | 0.0016164085 |
| Kurtosis | 0.91048764 |
| Mean | 2013.3654 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.83981615 |
| Sum | 14602939 |
| Variance | 10.591255 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2015 | 929 | |
| 2014 | 925 | |
| 2016 | 886 | |
| 2013 | 791 | |
| 2017 | 709 | |
| 2012 | 690 | |
| 2011 | 579 | |
| 2010 | 407 | |
| 2018 | 361 | 5.0% |
| 2009 | 252 | 3.5% |
| Other values (13) | 724 |
| Value | Count | Frequency (%) |
| 1996 | 1 | < 0.1% |
| 1998 | 4 | 0.1% |
| 1999 | 2 | < 0.1% |
| 2000 | 5 | 0.1% |
| 2001 | 8 | 0.1% |
| 2002 | 18 | 0.2% |
| 2003 | 20 | 0.3% |
| 2004 | 35 | 0.5% |
| 2005 | 68 | |
| 2006 | 89 |
| Value | Count | Frequency (%) |
| 2019 | 119 | 1.6% |
| 2018 | 361 | 5.0% |
| 2017 | 709 | |
| 2016 | 886 | |
| 2015 | 929 | |
| 2014 | 925 | |
| 2013 | 791 | |
| 2012 | 690 | |
| 2011 | 579 | |
| 2010 | 407 |
Kilometers_Driven
Real number (ℝ)
High correlation  Skewed 
| Distinct | 3660 |
|---|---|
| Distinct (%) | 50.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 58699.063 |
| Minimum | 171 |
|---|---|
| Maximum | 6500000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.8 KiB |
Quantile statistics
| Minimum | 171 |
|---|---|
| 5-th percentile | 13017.6 |
| Q1 | 34000 |
| median | 53416 |
| Q3 | 73000 |
| 95-th percentile | 120241.8 |
| Maximum | 6500000 |
| Range | 6499829 |
| Interquartile range (IQR) | 39000 |
Descriptive statistics
| Standard deviation | 84427.721 |
|---|---|
| Coefficient of variation (CV) | 1.4383146 |
| Kurtosis | 4674.734 |
| Mean | 58699.063 |
| Median Absolute Deviation (MAD) | 19584 |
| Skewness | 61.582575 |
| Sum | 4.257443 × 108 |
| Variance | 7.12804 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 60000 | 96 | 1.3% |
| 65000 | 86 | 1.2% |
| 45000 | 86 | 1.2% |
| 70000 | 77 | 1.1% |
| 50000 | 72 | 1.0% |
| 55000 | 66 | 0.9% |
| 75000 | 64 | 0.9% |
| 52000 | 62 | 0.9% |
| 35000 | 62 | 0.9% |
| 80000 | 62 | 0.9% |
| Other values (3650) | 6520 |
| Value | Count | Frequency (%) |
| 171 | 1 | < 0.1% |
| 600 | 1 | < 0.1% |
| 1000 | 11 | |
| 1001 | 4 | 0.1% |
| 1011 | 1 | < 0.1% |
| 1015 | 1 | < 0.1% |
| 1048 | 1 | < 0.1% |
| 1261 | 1 | < 0.1% |
| 1331 | 1 | < 0.1% |
| 1400 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6500000 | 1 | |
| 775000 | 1 | |
| 720000 | 1 | |
| 620000 | 1 | |
| 480000 | 2 | |
| 445000 | 1 | |
| 350000 | 1 | |
| 300000 | 1 | |
| 299322 | 1 | |
| 290000 | 1 |
Fuel_Type
Categorical
Imbalance 
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 389.5 KiB |
| Diesel | |
|---|---|
| Petrol | |
| CNG | 62 |
| LPG | 12 |
| Electric | 2 |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 5.9699435 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CNG |
|---|---|
| 2nd row | Diesel |
| 3rd row | Petrol |
| 4th row | Diesel |
| 5th row | Diesel |
Common Values
| Value | Count | Frequency (%) |
| Diesel | 3852 | |
| Petrol | 3325 | |
| CNG | 62 | 0.9% |
| LPG | 12 | 0.2% |
| Electric | 2 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| diesel | 3852 | |
| petrol | 3325 | |
| cng | 62 | 0.9% |
| lpg | 12 | 0.2% |
| electric | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 11031 | |
| l | 7179 | |
| i | 3854 | 8.9% |
| D | 3852 | 8.9% |
| s | 3852 | 8.9% |
| P | 3337 | 7.7% |
| t | 3327 | 7.7% |
| r | 3327 | 7.7% |
| o | 3325 | 7.7% |
| G | 74 | 0.2% |
| Other values (5) | 142 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 35899 | |
| Uppercase Letter | 7401 | 17.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 11031 | |
| l | 7179 | |
| i | 3854 | 10.7% |
| s | 3852 | 10.7% |
| t | 3327 | 9.3% |
| r | 3327 | 9.3% |
| o | 3325 | 9.3% |
| c | 4 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 3852 | |
| P | 3337 | |
| G | 74 | 1.0% |
| C | 62 | 0.8% |
| N | 62 | 0.8% |
| L | 12 | 0.2% |
| E | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 43300 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 11031 | |
| l | 7179 | |
| i | 3854 | 8.9% |
| D | 3852 | 8.9% |
| s | 3852 | 8.9% |
| P | 3337 | 7.7% |
| t | 3327 | 7.7% |
| r | 3327 | 7.7% |
| o | 3325 | 7.7% |
| G | 74 | 0.2% |
| Other values (5) | 142 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 43300 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 11031 | |
| l | 7179 | |
| i | 3854 | 8.9% |
| D | 3852 | 8.9% |
| s | 3852 | 8.9% |
| P | 3337 | 7.7% |
| t | 3327 | 7.7% |
| r | 3327 | 7.7% |
| o | 3325 | 7.7% |
| G | 74 | 0.2% |
| Other values (5) | 142 | 0.3% |
Transmission
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 395.7 KiB |
| Manual | |
|---|---|
| Automatic |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 6.8475114 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Manual |
|---|---|
| 2nd row | Manual |
| 3rd row | Manual |
| 4th row | Manual |
| 5th row | Automatic |
Common Values
| Value | Count | Frequency (%) |
| Manual | 5204 | |
| Automatic | 2049 | 28.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| manual | 5204 | |
| automatic | 2049 | 28.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 12457 | |
| u | 7253 | |
| M | 5204 | |
| n | 5204 | |
| l | 5204 | |
| t | 4098 | 8.3% |
| A | 2049 | 4.1% |
| o | 2049 | 4.1% |
| m | 2049 | 4.1% |
| i | 2049 | 4.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 42412 | |
| Uppercase Letter | 7253 | 14.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 12457 | |
| u | 7253 | |
| n | 5204 | |
| l | 5204 | |
| t | 4098 | 9.7% |
| o | 2049 | 4.8% |
| m | 2049 | 4.8% |
| i | 2049 | 4.8% |
| c | 2049 | 4.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 5204 | |
| A | 2049 | 28.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49665 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 12457 | |
| u | 7253 | |
| M | 5204 | |
| n | 5204 | |
| l | 5204 | |
| t | 4098 | 8.3% |
| A | 2049 | 4.1% |
| o | 2049 | 4.1% |
| m | 2049 | 4.1% |
| i | 2049 | 4.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49665 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 12457 | |
| u | 7253 | |
| M | 5204 | |
| n | 5204 | |
| l | 5204 | |
| t | 4098 | 8.3% |
| A | 2049 | 4.1% |
| o | 2049 | 4.1% |
| m | 2049 | 4.1% |
| i | 2049 | 4.1% |
Owner_Type
Categorical
Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 383.8 KiB |
| First | |
|---|---|
| Second | |
| Third | 137 |
| Fourth & Above | 12 |
Length
| Max length | 14 |
|---|---|
| Median length | 5 |
| Mean length | 5.1737212 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | First |
|---|---|
| 2nd row | First |
| 3rd row | First |
| 4th row | First |
| 5th row | Second |
Common Values
| Value | Count | Frequency (%) |
| First | 5952 | |
| Second | 1152 | 15.9% |
| Third | 137 | 1.9% |
| Fourth & Above | 12 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| first | 5952 | |
| second | 1152 | 15.8% |
| third | 137 | 1.9% |
| fourth | 12 | 0.2% |
| 12 | 0.2% | |
| above | 12 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 6101 | |
| i | 6089 | |
| F | 5964 | |
| t | 5964 | |
| s | 5952 | |
| d | 1289 | 3.4% |
| o | 1176 | 3.1% |
| e | 1164 | 3.1% |
| n | 1152 | 3.1% |
| c | 1152 | 3.1% |
| Other values (9) | 1522 | 4.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 30224 | |
| Uppercase Letter | 7265 | 19.4% |
| Space Separator | 24 | 0.1% |
| Other Punctuation | 12 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 6101 | |
| i | 6089 | |
| t | 5964 | |
| s | 5952 | |
| d | 1289 | 4.3% |
| o | 1176 | 3.9% |
| e | 1164 | 3.9% |
| n | 1152 | 3.8% |
| c | 1152 | 3.8% |
| h | 149 | 0.5% |
| Other values (3) | 36 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 5964 | |
| S | 1152 | 15.9% |
| T | 137 | 1.9% |
| A | 12 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 24 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 12 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 37489 | |
| Common | 36 | 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 6101 | |
| i | 6089 | |
| F | 5964 | |
| t | 5964 | |
| s | 5952 | |
| d | 1289 | 3.4% |
| o | 1176 | 3.1% |
| e | 1164 | 3.1% |
| n | 1152 | 3.1% |
| c | 1152 | 3.1% |
| Other values (7) | 1486 | 4.0% |
Common
| Value | Count | Frequency (%) |
| 24 | ||
| & | 12 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 37525 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 6101 | |
| i | 6089 | |
| F | 5964 | |
| t | 5964 | |
| s | 5952 | |
| d | 1289 | 3.4% |
| o | 1176 | 3.1% |
| e | 1164 | 3.1% |
| n | 1152 | 3.1% |
| c | 1152 | 3.1% |
| Other values (9) | 1522 | 4.1% |
Mileage
Unsupported
Missing  Rejected  Unsupported 
| Missing | 7253 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 56.8 KiB |
Engine
Unsupported
Missing  Rejected  Unsupported 
| Missing | 7253 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 56.8 KiB |
Power
Unsupported
Missing  Rejected  Unsupported 
| Missing | 7253 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 56.8 KiB |
Seats
Real number (ℝ)
| Distinct | 9 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 23 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.2791148 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 5 |
| median | 5 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.81066572 |
|---|---|
| Coefficient of variation (CV) | 0.15356092 |
| Kurtosis | 4.7205148 |
| Mean | 5.2791148 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.9060758 |
| Sum | 38168 |
| Variance | 0.65717891 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 6075 | |
| 7 | 798 | 11.0% |
| 8 | 170 | 2.3% |
| 4 | 119 | 1.6% |
| 6 | 38 | 0.5% |
| 2 | 18 | 0.2% |
| 10 | 8 | 0.1% |
| 9 | 3 | < 0.1% |
| 0 | 1 | < 0.1% |
| (Missing) | 23 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 2 | 18 | 0.2% |
| 4 | 119 | 1.6% |
| 5 | 6075 | |
| 6 | 38 | 0.5% |
| 7 | 798 | 11.0% |
| 8 | 170 | 2.3% |
| 9 | 3 | < 0.1% |
| 10 | 8 | 0.1% |
| Value | Count | Frequency (%) |
| 10 | 8 | 0.1% |
| 9 | 3 | < 0.1% |
| 8 | 170 | 2.3% |
| 7 | 798 | 11.0% |
| 6 | 38 | 0.5% |
| 5 | 6075 | |
| 4 | 119 | 1.6% |
| 2 | 18 | 0.2% |
| 0 | 1 | < 0.1% |
New_Price
Text
Missing 
| Distinct | 625 |
|---|---|
| Distinct (%) | 62.1% |
| Missing | 6247 |
| Missing (%) | 86.1% |
| Memory size | 252.7 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.4194831 |
| Min length | 4 |
Unique
| Unique | 391 ? |
|---|---|
| Unique (%) | 38.9% |
Sample
| 1st row | 8.61 Lakh |
|---|---|
| 2nd row | 21 Lakh |
| 3rd row | 10.65 Lakh |
| 4th row | 32.01 Lakh |
| 5th row | 47.87 Lakh |
| Value | Count | Frequency (%) |
| lakh | 986 | |
| cr | 20 | 1.0% |
| 33.36 | 6 | 0.3% |
| 95.13 | 6 | 0.3% |
| 4.78 | 6 | 0.3% |
| 63.71 | 6 | 0.3% |
| 15.05 | 5 | 0.2% |
| 11.48 | 5 | 0.2% |
| 4.98 | 5 | 0.2% |
| 11.26 | 5 | 0.2% |
| Other values (617) | 962 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1006 | ||
| . | 989 | |
| L | 986 | |
| a | 986 | |
| k | 986 | |
| h | 986 | |
| 1 | 627 | 6.6% |
| 4 | 386 | 4.1% |
| 5 | 371 | 3.9% |
| 7 | 356 | 3.8% |
| Other values (8) | 1797 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3497 | |
| Lowercase Letter | 2978 | |
| Space Separator | 1006 | 10.6% |
| Uppercase Letter | 1006 | 10.6% |
| Other Punctuation | 989 | 10.4% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 627 | |
| 4 | 386 | |
| 5 | 371 | |
| 7 | 356 | |
| 6 | 345 | |
| 2 | 325 | |
| 8 | 310 | |
| 3 | 307 | |
| 9 | 290 | |
| 0 | 180 | 5.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 986 | |
| k | 986 | |
| h | 986 | |
| r | 20 | 0.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 986 | |
| C | 20 | 2.0% |
Space Separator
| Value | Count | Frequency (%) |
| 1006 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 989 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5492 | |
| Latin | 3984 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1006 | ||
| . | 989 | |
| 1 | 627 | |
| 4 | 386 | 7.0% |
| 5 | 371 | 6.8% |
| 7 | 356 | 6.5% |
| 6 | 345 | 6.3% |
| 2 | 325 | 5.9% |
| 8 | 310 | 5.6% |
| 3 | 307 | 5.6% |
| Other values (2) | 470 |
Latin
| Value | Count | Frequency (%) |
| L | 986 | |
| a | 986 | |
| k | 986 | |
| h | 986 | |
| C | 20 | 0.5% |
| r | 20 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9476 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1006 | ||
| . | 989 | |
| L | 986 | |
| a | 986 | |
| k | 986 | |
| h | 986 | |
| 1 | 627 | 6.6% |
| 4 | 386 | 4.1% |
| 5 | 371 | 3.9% |
| 7 | 356 | 3.8% |
| Other values (8) | 1797 |
Price
Real number (ℝ)
High correlation  Missing 
| Distinct | 1373 |
|---|---|
| Distinct (%) | 22.8% |
| Missing | 1234 |
| Missing (%) | 17.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.4794684 |
| Minimum | 0.44 |
|---|---|
| Maximum | 160 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.8 KiB |
Quantile statistics
| Minimum | 0.44 |
|---|---|
| 5-th percentile | 1.7 |
| Q1 | 3.5 |
| median | 5.64 |
| Q3 | 9.95 |
| 95-th percentile | 32.446 |
| Maximum | 160 |
| Range | 159.56 |
| Interquartile range (IQR) | 6.45 |
Descriptive statistics
| Standard deviation | 11.187917 |
|---|---|
| Coefficient of variation (CV) | 1.1802262 |
| Kurtosis | 17.092202 |
| Mean | 9.4794684 |
| Median Absolute Deviation (MAD) | 2.62 |
| Skewness | 3.335232 |
| Sum | 57056.92 |
| Variance | 125.16949 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.5 | 88 | 1.2% |
| 5.5 | 84 | 1.2% |
| 3.5 | 82 | 1.1% |
| 4.25 | 73 | 1.0% |
| 3.25 | 71 | 1.0% |
| 3 | 68 | 0.9% |
| 6.5 | 64 | 0.9% |
| 2.5 | 63 | 0.9% |
| 4 | 56 | 0.8% |
| 4.75 | 53 | 0.7% |
| Other values (1363) | 5317 | |
| (Missing) | 1234 | 17.0% |
| Value | Count | Frequency (%) |
| 0.44 | 1 | < 0.1% |
| 0.45 | 3 | |
| 0.5 | 2 | |
| 0.51 | 1 | < 0.1% |
| 0.53 | 2 | |
| 0.55 | 3 | |
| 0.6 | 2 | |
| 0.63 | 1 | < 0.1% |
| 0.65 | 2 | |
| 0.69 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 160 | 1 | |
| 120 | 1 | |
| 100 | 1 | |
| 97.07 | 1 | |
| 93.67 | 1 | |
| 93 | 1 | |
| 90 | 1 | |
| 85 | 1 | |
| 83.96 | 1 | |
| 79 | 2 |
Car_Age
Real number (ℝ)
High correlation 
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.634634 |
| Minimum | 6 |
|---|---|
| Maximum | 29 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.8 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 9 |
| median | 11 |
| Q3 | 14 |
| 95-th percentile | 18 |
| Maximum | 29 |
| Range | 23 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.2544208 |
|---|---|
| Coefficient of variation (CV) | 0.27971837 |
| Kurtosis | 0.91048764 |
| Mean | 11.634634 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.83981615 |
| Sum | 84386 |
| Variance | 10.591255 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 929 | |
| 11 | 925 | |
| 9 | 886 | |
| 12 | 791 | |
| 8 | 709 | |
| 13 | 690 | |
| 14 | 579 | |
| 15 | 407 | |
| 7 | 361 | 5.0% |
| 16 | 252 | 3.5% |
| Other values (13) | 724 |
| Value | Count | Frequency (%) |
| 6 | 119 | 1.6% |
| 7 | 361 | 5.0% |
| 8 | 709 | |
| 9 | 886 | |
| 10 | 929 | |
| 11 | 925 | |
| 12 | 791 | |
| 13 | 690 | |
| 14 | 579 | |
| 15 | 407 |
| Value | Count | Frequency (%) |
| 29 | 1 | < 0.1% |
| 27 | 4 | 0.1% |
| 26 | 2 | < 0.1% |
| 25 | 5 | 0.1% |
| 24 | 8 | 0.1% |
| 23 | 18 | 0.2% |
| 22 | 20 | 0.3% |
| 21 | 35 | 0.5% |
| 20 | 68 | |
| 19 | 89 |
Brand
Categorical
High correlation 
| Distinct | 32 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 393.2 KiB |
| Maruti | |
|---|---|
| Hyundai | |
| Honda | |
| Toyota | |
| Mercedes-Benz | |
| Other values (27) |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 6.4996553 |
| Min length | 3 |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Maruti |
|---|---|
| 2nd row | Hyundai |
| 3rd row | Honda |
| 4th row | Maruti |
| 5th row | Audi |
Common Values
| Value | Count | Frequency (%) |
| Maruti | 1444 | |
| Hyundai | 1340 | |
| Honda | 743 | |
| Toyota | 507 | 7.0% |
| Mercedes-Benz | 380 | 5.2% |
| Volkswagen | 374 | 5.2% |
| Ford | 351 | 4.8% |
| Mahindra | 331 | 4.6% |
| BMW | 312 | 4.3% |
| Audi | 285 | 3.9% |
| Other values (22) | 1186 |
Length
| Value | Count | Frequency (%) |
| maruti | 1444 | |
| hyundai | 1340 | |
| honda | 743 | |
| toyota | 507 | 6.9% |
| mercedes-benz | 380 | 5.2% |
| volkswagen | 374 | 5.1% |
| ford | 351 | 4.8% |
| mahindra | 331 | 4.5% |
| bmw | 312 | 4.2% |
| audi | 285 | 3.9% |
| Other values (24) | 1284 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 6239 | |
| i | 3728 | 7.9% |
| d | 3701 | 7.9% |
| n | 3575 | 7.6% |
| u | 3351 | 7.1% |
| o | 3045 | 6.5% |
| r | 2829 | 6.0% |
| t | 2595 | 5.5% |
| M | 2534 | 5.4% |
| e | 2529 | 5.4% |
| Other values (32) | 13016 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 38308 | |
| Uppercase Letter | 8356 | 17.7% |
| Dash Punctuation | 380 | 0.8% |
| Space Separator | 98 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 6239 | |
| i | 3728 | |
| d | 3701 | |
| n | 3575 | |
| u | 3351 | |
| o | 3045 | |
| r | 2829 | |
| t | 2595 | |
| e | 2529 | |
| y | 1849 | 4.8% |
| Other values (12) | 4867 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 2534 | |
| H | 2084 | |
| T | 735 | 8.8% |
| B | 694 | 8.3% |
| V | 402 | 4.8% |
| F | 392 | 4.7% |
| W | 312 | 3.7% |
| A | 286 | 3.4% |
| R | 237 | 2.8% |
| S | 203 | 2.4% |
| Other values (8) | 477 | 5.7% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 380 |
Space Separator
| Value | Count | Frequency (%) |
| 98 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 46664 | |
| Common | 478 | 1.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 6239 | |
| i | 3728 | 8.0% |
| d | 3701 | 7.9% |
| n | 3575 | 7.7% |
| u | 3351 | 7.2% |
| o | 3045 | 6.5% |
| r | 2829 | 6.1% |
| t | 2595 | 5.6% |
| M | 2534 | 5.4% |
| e | 2529 | 5.4% |
| Other values (30) | 12538 |
Common
| Value | Count | Frequency (%) |
| - | 380 | |
| 98 | 20.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 47142 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 6239 | |
| i | 3728 | 7.9% |
| d | 3701 | 7.9% |
| n | 3575 | 7.6% |
| u | 3351 | 7.1% |
| o | 3045 | 6.5% |
| r | 2829 | 6.0% |
| t | 2595 | 5.5% |
| M | 2534 | 5.4% |
| e | 2529 | 5.4% |
| Other values (32) | 13016 |
Model
Text
| Distinct | 726 |
|---|---|
| Distinct (%) | 10.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 408.1 KiB |
Length
| Max length | 18 |
|---|---|
| Median length | 15 |
| Mean length | 8.5990072 |
| Min length | 3 |
Unique
| Unique | 191 ? |
|---|---|
| Unique (%) | 2.6% |
Sample
| 1st row | WagonR |
|---|---|
| 2nd row | Creta1.6 |
| 3rd row | JazzV |
| 4th row | ErtigaVDI |
| 5th row | A4New |
| Value | Count | Frequency (%) |
| swiftdzire | 189 | 2.6% |
| grandi10 | 179 | 2.5% |
| wagonr | 178 | 2.5% |
| innova2.5 | 145 | 2.0% |
| verna1.6 | 127 | 1.8% |
| city1.5 | 122 | 1.7% |
| cityi | 115 | 1.6% |
| creta1.6 | 110 | 1.5% |
| newc-class | 110 | 1.5% |
| 3series | 109 | 1.5% |
| Other values (695) | 5868 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 4369 | 7.0% |
| a | 3887 | 6.2% |
| e | 3808 | 6.1% |
| o | 3372 | 5.4% |
| r | 3307 | 5.3% |
| t | 3134 | 5.0% |
| 0 | 2514 | 4.0% |
| n | 2509 | 4.0% |
| 1 | 2339 | 3.8% |
| s | 1991 | 3.2% |
| Other values (58) | 31130 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 35330 | |
| Uppercase Letter | 14825 | |
| Decimal Number | 9801 | 15.7% |
| Other Punctuation | 1703 | 2.7% |
| Dash Punctuation | 699 | 1.1% |
| Open Punctuation | 1 | < 0.1% |
| Close Punctuation | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 4369 | |
| a | 3887 | |
| e | 3808 | |
| o | 3372 | |
| r | 3307 | |
| t | 3134 | |
| n | 2509 | |
| s | 1991 | 5.6% |
| l | 1792 | 5.1% |
| z | 945 | 2.7% |
| Other values (16) | 6216 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1767 | |
| C | 1626 | |
| V | 1292 | 8.7% |
| D | 1162 | 7.8% |
| X | 1090 | 7.4% |
| A | 960 | 6.5% |
| E | 947 | 6.4% |
| I | 746 | 5.0% |
| R | 636 | 4.3% |
| L | 633 | 4.3% |
| Other values (16) | 3966 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 2514 | |
| 1 | 2339 | |
| 2 | 1844 | |
| 5 | 1087 | |
| 3 | 526 | 5.4% |
| 4 | 497 | 5.1% |
| 6 | 466 | 4.8% |
| 8 | 292 | 3.0% |
| 7 | 139 | 1.4% |
| 9 | 97 | 1.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1698 | |
| & | 4 | 0.2% |
| / | 1 | 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 699 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 50155 | |
| Common | 12205 | 19.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 4369 | 8.7% |
| a | 3887 | 7.7% |
| e | 3808 | 7.6% |
| o | 3372 | 6.7% |
| r | 3307 | 6.6% |
| t | 3134 | 6.2% |
| n | 2509 | 5.0% |
| s | 1991 | 4.0% |
| l | 1792 | 3.6% |
| S | 1767 | 3.5% |
| Other values (42) | 20219 |
Common
| Value | Count | Frequency (%) |
| 0 | 2514 | |
| 1 | 2339 | |
| 2 | 1844 | |
| . | 1698 | |
| 5 | 1087 | |
| - | 699 | 5.7% |
| 3 | 526 | 4.3% |
| 4 | 497 | 4.1% |
| 6 | 466 | 3.8% |
| 8 | 292 | 2.4% |
| Other values (6) | 243 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 62360 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 4369 | 7.0% |
| a | 3887 | 6.2% |
| e | 3808 | 6.1% |
| o | 3372 | 5.4% |
| r | 3307 | 5.3% |
| t | 3134 | 5.0% |
| 0 | 2514 | 4.0% |
| n | 2509 | 4.0% |
| 1 | 2339 | 3.8% |
| s | 1991 | 3.2% |
| Other values (58) | 31130 |
Kilometers_Driven_log
Real number (ℝ)
High correlation 
| Distinct | 3660 |
|---|---|
| Distinct (%) | 50.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.760978 |
| Minimum | 5.1416636 |
|---|---|
| Maximum | 15.687313 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.8 KiB |
Quantile statistics
| Minimum | 5.1416636 |
|---|---|
| 5-th percentile | 9.4740574 |
| Q1 | 10.434116 |
| median | 10.885866 |
| Q3 | 11.198215 |
| 95-th percentile | 11.69726 |
| Maximum | 15.687313 |
| Range | 10.545649 |
| Interquartile range (IQR) | 0.76409892 |
Descriptive statistics
| Standard deviation | 0.71632692 |
|---|---|
| Coefficient of variation (CV) | 0.066567084 |
| Kurtosis | 4.58503 |
| Mean | 10.760978 |
| Median Absolute Deviation (MAD) | 0.3680847 |
| Skewness | -1.2987715 |
| Sum | 78049.373 |
| Variance | 0.51312426 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11.00209984 | 96 | 1.3% |
| 11.08214255 | 86 | 1.2% |
| 10.71441777 | 86 | 1.2% |
| 11.15625052 | 77 | 1.1% |
| 10.81977828 | 72 | 1.0% |
| 10.91508846 | 66 | 0.9% |
| 11.22524339 | 64 | 0.9% |
| 10.858999 | 62 | 0.9% |
| 10.46310334 | 62 | 0.9% |
| 11.28978191 | 62 | 0.9% |
| Other values (3650) | 6520 |
| Value | Count | Frequency (%) |
| 5.141663557 | 1 | < 0.1% |
| 6.396929655 | 1 | < 0.1% |
| 6.907755279 | 11 | |
| 6.908754779 | 4 | 0.1% |
| 6.918695219 | 1 | < 0.1% |
| 6.922643891 | 1 | < 0.1% |
| 6.954638865 | 1 | < 0.1% |
| 7.139660336 | 1 | < 0.1% |
| 7.193685818 | 1 | < 0.1% |
| 7.244227516 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 15.68731273 | 1 | |
| 13.56061831 | 1 | |
| 13.48700649 | 1 | |
| 13.33747476 | 1 | |
| 13.08154138 | 2 | |
| 13.00582956 | 1 | |
| 12.76568843 | 1 | |
| 12.61153775 | 1 | |
| 12.6092752 | 1 | |
| 12.5776362 | 1 |
Price_log
Real number (ℝ)
High correlation  Missing 
| Distinct | 1373 |
|---|---|
| Distinct (%) | 22.8% |
| Missing | 1234 |
| Missing (%) | 17.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.8250951 |
| Minimum | -0.82098055 |
|---|---|
| Maximum | 5.0751738 |
| Zeros | 15 |
| Zeros (%) | 0.2% |
| Negative | 77 |
| Negative (%) | 1.1% |
| Memory size | 56.8 KiB |
Quantile statistics
| Minimum | -0.82098055 |
|---|---|
| 5-th percentile | 0.53062825 |
| Q1 | 1.252763 |
| median | 1.7298841 |
| Q3 | 2.2975726 |
| 95-th percentile | 3.479577 |
| Maximum | 5.0751738 |
| Range | 5.8961544 |
| Interquartile range (IQR) | 1.0448096 |
Descriptive statistics
| Standard deviation | 0.8740586 |
|---|---|
| Coefficient of variation (CV) | 0.47891126 |
| Kurtosis | 0.17272636 |
| Mean | 1.8250951 |
| Median Absolute Deviation (MAD) | 0.51613068 |
| Skewness | 0.41739069 |
| Sum | 10985.248 |
| Variance | 0.76397844 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.504077397 | 88 | 1.2% |
| 1.704748092 | 84 | 1.2% |
| 1.252762968 | 82 | 1.1% |
| 1.446918983 | 73 | 1.0% |
| 1.178654996 | 71 | 1.0% |
| 1.098612289 | 68 | 0.9% |
| 1.871802177 | 64 | 0.9% |
| 0.9162907319 | 63 | 0.9% |
| 1.386294361 | 56 | 0.8% |
| 1.558144618 | 53 | 0.7% |
| Other values (1363) | 5317 | |
| (Missing) | 1234 | 17.0% |
| Value | Count | Frequency (%) |
| -0.8209805521 | 1 | < 0.1% |
| -0.7985076962 | 3 | |
| -0.6931471806 | 2 | |
| -0.6733445533 | 1 | < 0.1% |
| -0.6348782724 | 2 | |
| -0.5978370008 | 3 | |
| -0.5108256238 | 2 | |
| -0.4620354596 | 1 | < 0.1% |
| -0.4307829161 | 2 | |
| -0.3710636814 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5.075173815 | 1 | |
| 4.787491743 | 1 | |
| 4.605170186 | 1 | |
| 4.575432368 | 1 | |
| 4.539777967 | 1 | |
| 4.532599493 | 1 | |
| 4.49980967 | 1 | |
| 4.442651256 | 1 | |
| 4.430340495 | 1 | |
| 4.369447852 | 2 |
Interactions
Correlations
| Brand | Car_Age | Fuel_Type | Kilometers_Driven | Kilometers_Driven_log | Location | Owner_Type | Price | Price_log | Seats | Transmission | Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Brand | 1.000 | 0.177 | 0.244 | 0.000 | 0.113 | 0.084 | 0.084 | 0.465 | 0.348 | 0.346 | 0.699 | 0.177 |
| Car_Age | 0.177 | 1.000 | 0.095 | 0.552 | 0.552 | 0.136 | 0.251 | -0.491 | -0.491 | -0.033 | 0.101 | -1.000 |
| Fuel_Type | 0.244 | 0.095 | 1.000 | 0.000 | 0.117 | 0.093 | 0.023 | 0.148 | 0.222 | 0.160 | 0.150 | 0.095 |
| Kilometers_Driven | 0.000 | 0.552 | 0.000 | 1.000 | 1.000 | 0.008 | 0.000 | -0.215 | -0.215 | 0.190 | 0.012 | -0.552 |
| Kilometers_Driven_log | 0.113 | 0.552 | 0.117 | 1.000 | 1.000 | 0.121 | 0.124 | -0.215 | -0.215 | 0.190 | 0.099 | -0.552 |
| Location | 0.084 | 0.136 | 0.093 | 0.008 | 0.121 | 1.000 | 0.160 | 0.074 | 0.121 | 0.025 | 0.195 | 0.136 |
| Owner_Type | 0.084 | 0.251 | 0.023 | 0.000 | 0.124 | 0.160 | 1.000 | 0.058 | 0.173 | 0.046 | 0.007 | 0.251 |
| Price | 0.465 | -0.491 | 0.148 | -0.215 | -0.215 | 0.074 | 0.058 | 1.000 | 1.000 | 0.221 | 0.595 | 0.491 |
| Price_log | 0.348 | -0.491 | 0.222 | -0.215 | -0.215 | 0.121 | 0.173 | 1.000 | 1.000 | 0.221 | 0.661 | 0.491 |
| Seats | 0.346 | -0.033 | 0.160 | 0.190 | 0.190 | 0.025 | 0.046 | 0.221 | 0.221 | 1.000 | 0.146 | 0.033 |
| Transmission | 0.699 | 0.101 | 0.150 | 0.012 | 0.099 | 0.195 | 0.007 | 0.595 | 0.661 | 0.146 | 1.000 | 0.101 |
| Year | 0.177 | -1.000 | 0.095 | -0.552 | -0.552 | 0.136 | 0.251 | 0.491 | 0.491 | 0.033 | 0.101 | 1.000 |
Missing values
Sample
| Name | Location | Year | Kilometers_Driven | Fuel_Type | Transmission | Owner_Type | Mileage | Engine | Power | Seats | New_Price | Price | Car_Age | Brand | Model | Kilometers_Driven_log | Price_log | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Maruti Wagon R LXI CNG | Mumbai | 2010 | 72000 | CNG | Manual | First | NaN | NaN | NaN | 5.0 | NaN | 1.75 | 15 | Maruti | WagonR | 11.184421 | 0.559616 |
| 1 | Hyundai Creta 1.6 CRDi SX Option | Pune | 2015 | 41000 | Diesel | Manual | First | NaN | NaN | NaN | 5.0 | NaN | 12.50 | 10 | Hyundai | Creta1.6 | 10.621327 | 2.525729 |
| 2 | Honda Jazz V | Chennai | 2011 | 46000 | Petrol | Manual | First | NaN | NaN | NaN | 5.0 | 8.61 Lakh | 4.50 | 14 | Honda | JazzV | 10.736397 | 1.504077 |
| 3 | Maruti Ertiga VDI | Chennai | 2012 | 87000 | Diesel | Manual | First | NaN | NaN | NaN | 7.0 | NaN | 6.00 | 13 | Maruti | ErtigaVDI | 11.373663 | 1.791759 |
| 4 | Audi A4 New 2.0 TDI Multitronic | Coimbatore | 2013 | 40670 | Diesel | Automatic | Second | NaN | NaN | NaN | 5.0 | NaN | 17.74 | 12 | Audi | A4New | 10.613246 | 2.875822 |
| 5 | Hyundai EON LPG Era Plus Option | Hyderabad | 2012 | 75000 | LPG | Manual | First | NaN | NaN | NaN | 5.0 | NaN | 2.35 | 13 | Hyundai | EONLPG | 11.225243 | 0.854415 |
| 6 | Nissan Micra Diesel XV | Jaipur | 2013 | 86999 | Diesel | Manual | First | NaN | NaN | NaN | 5.0 | NaN | 3.50 | 12 | Nissan | MicraDiesel | 11.373652 | 1.252763 |
| 7 | Toyota Innova Crysta 2.8 GX AT 8S | Mumbai | 2016 | 36000 | Diesel | Automatic | First | NaN | NaN | NaN | 8.0 | 21 Lakh | 17.50 | 9 | Toyota | InnovaCrysta | 10.491274 | 2.862201 |
| 8 | Volkswagen Vento Diesel Comfortline | Pune | 2013 | 64430 | Diesel | Manual | First | NaN | NaN | NaN | 5.0 | NaN | 5.20 | 12 | Volkswagen | VentoDiesel | 11.073335 | 1.648659 |
| 9 | Tata Indica Vista Quadrajet LS | Chennai | 2012 | 65932 | Diesel | Manual | Second | NaN | NaN | NaN | 5.0 | NaN | 1.95 | 13 | Tata | IndicaVista | 11.096379 | 0.667829 |
| Name | Location | Year | Kilometers_Driven | Fuel_Type | Transmission | Owner_Type | Mileage | Engine | Power | Seats | New_Price | Price | Car_Age | Brand | Model | Kilometers_Driven_log | Price_log | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7243 | Renault Duster 85PS Diesel RxL | Chennai | 2015 | 70000 | Diesel | Manual | First | NaN | NaN | NaN | 5.0 | NaN | NaN | 10 | Renault | Duster85PS | 11.156251 | NaN |
| 7244 | Chevrolet Aveo 1.4 LS | Pune | 2009 | 45463 | Petrol | Manual | First | NaN | NaN | NaN | 5.0 | NaN | NaN | 16 | Chevrolet | Aveo1.4 | 10.724654 | NaN |
| 7245 | Honda Amaze S i-Vtech | Kochi | 2015 | 44776 | Petrol | Manual | First | NaN | NaN | NaN | 5.0 | NaN | NaN | 10 | Honda | AmazeS | 10.709428 | NaN |
| 7246 | Hyundai Grand i10 AT Asta | Coimbatore | 2016 | 18242 | Petrol | Automatic | First | NaN | NaN | NaN | 5.0 | NaN | NaN | 9 | Hyundai | Grandi10 | 9.811482 | NaN |
| 7247 | Hyundai EON D Lite Plus | Coimbatore | 2015 | 21190 | Petrol | Manual | First | NaN | NaN | NaN | 5.0 | NaN | NaN | 10 | Hyundai | EOND | 9.961285 | NaN |
| 7248 | Volkswagen Vento Diesel Trendline | Hyderabad | 2011 | 89411 | Diesel | Manual | First | NaN | NaN | NaN | 5.0 | NaN | NaN | 14 | Volkswagen | VentoDiesel | 11.400999 | NaN |
| 7249 | Volkswagen Polo GT TSI | Mumbai | 2015 | 59000 | Petrol | Automatic | First | NaN | NaN | NaN | 5.0 | NaN | NaN | 10 | Volkswagen | PoloGT | 10.985293 | NaN |
| 7250 | Nissan Micra Diesel XV | Kolkata | 2012 | 28000 | Diesel | Manual | First | NaN | NaN | NaN | 5.0 | NaN | NaN | 13 | Nissan | MicraDiesel | 10.239960 | NaN |
| 7251 | Volkswagen Polo GT TSI | Pune | 2013 | 52262 | Petrol | Automatic | Third | NaN | NaN | NaN | 5.0 | NaN | NaN | 12 | Volkswagen | PoloGT | 10.864025 | NaN |
| 7252 | Mercedes-Benz E-Class 2009-2013 E 220 CDI Avantgarde | Kochi | 2014 | 72443 | Diesel | Automatic | First | NaN | NaN | NaN | 5.0 | NaN | NaN | 11 | Mercedes-Benz | E-Class2009-2013 | 11.190555 | NaN |
Duplicate rows
Most frequently occurring
| Name | Location | Year | Kilometers_Driven | Fuel_Type | Transmission | Owner_Type | Seats | New_Price | Price | Car_Age | Brand | Model | Kilometers_Driven_log | Price_log | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Honda City 1.5 E MT | Mumbai | 2010 | 52000 | Petrol | Manual | First | 5.0 | NaN | NaN | 15 | Honda | City1.5 | 10.858999 | NaN | 2 |